/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_attr_value_spec.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_ATTR_VALUE_SPEC
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_attr_value_spec.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "app97_global.h" 
#include "table_ppm.h"

CTable_PPM_ATTR_VALUE_SPEC::CTable_PPM_ATTR_VALUE_SPEC( )
 :NPCRecordSet( )
{
  setTableName( "PPM_ATTR_VALUE_SPEC" );
  prepareTable();
  prepareQuery();
 
  ATTR_VALUE_ID.setField( "ATTR_VALUE_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ATTR_VALUE_ID );
  makeKeyItem( ATTR_VALUE_ID ); 
  ATTR_VALUE_NAME.setField( "ATTR_VALUE_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( ATTR_VALUE_NAME );
  ATTR_CD.setField( "ATTR_CD", DATA_CHAR, 30, 0 );
  makeTableItem( ATTR_CD );
  ATTR_DESC.setField( "ATTR_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( ATTR_DESC );
  ATTR_VALUE_TYPE.setField( "ATTR_VALUE_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( ATTR_VALUE_TYPE );
  ATTR_FORMAT.setField( "ATTR_FORMAT", DATA_CHAR, 64, 0 );
  makeTableItem( ATTR_FORMAT );
  ATTR_LENGTH.setField( "ATTR_LENGTH", DATA_DOUBLE, 22, 0 );
  makeTableItem( ATTR_LENGTH );
  ATTR_VALUE.setField( "ATTR_VALUE", DATA_CHAR, 4000, 0 );
  makeTableItem( ATTR_VALUE );
  MAX_VALUE.setField( "MAX_VALUE", DATA_CHAR, 64, 0 );
  makeTableItem( MAX_VALUE );
  MIN_VALUE.setField( "MIN_VALUE", DATA_CHAR, 64, 0 );
  makeTableItem( MIN_VALUE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  STATE_CD.setField( "STATE_CD", DATA_CHAR, 3, 0 );
  makeTableItem( STATE_CD );
	GROUP_ATTR_VALUE.setField( "GROUP_ATTR_VALUE", DATA_CHAR, 22, 0 );
  makeTableItem( GROUP_ATTR_VALUE );
}


CTable_PPM_ATTR_VALUE_SPEC::CTable_PPM_ATTR_VALUE_SPEC( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_ATTR_VALUE_SPEC" );
  prepareTable();
  prepareQuery();
 
  ATTR_VALUE_ID.setField( "ATTR_VALUE_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ATTR_VALUE_ID );
  makeKeyItem( ATTR_VALUE_ID ); 
  ATTR_VALUE_NAME.setField( "ATTR_VALUE_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( ATTR_VALUE_NAME );
  ATTR_CD.setField( "ATTR_CD", DATA_CHAR, 30, 0 );
  makeTableItem( ATTR_CD );
  ATTR_DESC.setField( "ATTR_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( ATTR_DESC );
  ATTR_VALUE_TYPE.setField( "ATTR_VALUE_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( ATTR_VALUE_TYPE );
  ATTR_FORMAT.setField( "ATTR_FORMAT", DATA_CHAR, 64, 0 );
  makeTableItem( ATTR_FORMAT );
  ATTR_LENGTH.setField( "ATTR_LENGTH", DATA_DOUBLE, 22, 0 );
  makeTableItem( ATTR_LENGTH );
  ATTR_VALUE.setField( "ATTR_VALUE", DATA_CHAR, 4000, 0 );
  makeTableItem( ATTR_VALUE );
  MAX_VALUE.setField( "MAX_VALUE", DATA_CHAR, 64, 0 );
  makeTableItem( MAX_VALUE );
  MIN_VALUE.setField( "MIN_VALUE", DATA_CHAR, 64, 0 );
  makeTableItem( MIN_VALUE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
  STATE_CD.setField( "STATE_CD", DATA_CHAR, 3, 0 );
  makeTableItem( STATE_CD );
	GROUP_ATTR_VALUE.setField( "GROUP_ATTR_VALUE", DATA_CHAR, 22, 0 );
  makeTableItem( GROUP_ATTR_VALUE );
}

CTable_PPM_ATTR_VALUE_SPEC::~CTable_PPM_ATTR_VALUE_SPEC( )
{
    close();
}

